def log_and_pubs_1():
  
  result = PubsTableAuthors.ExecSQL("select au_id, au_fname, au_lname from authors where city = \"Oakland\"") 
  MSLogTable.TestLastMessageID(CfgSCS, "31011")
  ScsDBServer1.Stop()
  MSLogTable.TestLastMessageID(CfgSCS, "31011")
  ScsDBServer1.Start()
  result = PubsTableAuthors.ExecSQL("select au_id, au_fname, au_lname from authors where city = \"Oakland\"") 
  MSLogTable.TestLastMessageID(CfgSCS, "31011")